CREATE TABLE [dbo].[UserDefinedCustomerExperience]
(
[UserDefinedCustomerExperienceKey] [uniqueidentifier] NOT NULL,
[ProgramKey] [uniqueidentifier] NOT NULL,
[UserDefinedCustomerExperienceName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UserDefinedCustomerExperienceDesc] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CompletionDate] [datetime] NOT NULL,
[UserDefinedCustomerExperienceUnits] [decimal] (18, 8) NULL,
[UserDefinedCustomerExperienceLocation] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UserDefinedCustomerExperience] ADD CONSTRAINT [PK_UserDefinedCustomerExperience_UserDefinedCustomerExperienceKey] PRIMARY KEY CLUSTERED ([UserDefinedCustomerExperienceKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedCustomerExperience_ProgramKey] ON [dbo].[UserDefinedCustomerExperience] ([ProgramKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserDefinedCustomerExperience] ADD CONSTRAINT [FK_UserDefinedCustomerExperience_CustomerExperience] FOREIGN KEY ([UserDefinedCustomerExperienceKey]) REFERENCES [dbo].[CustomerExperience] ([CustomerExperienceKey])
GO
ALTER TABLE [dbo].[UserDefinedCustomerExperience] ADD CONSTRAINT [FK_UserDefinedCustomerExperience_Program] FOREIGN KEY ([ProgramKey]) REFERENCES [dbo].[Program] ([ProgramKey])
GO